Evaluation of the Analytical Dashboard of Designed Health Insurance Deductions, based on Business Intelligence

Background and Aim: Large amounts of hospital costs are not reimbursed annually by health insurance as deductions. Therefore, reducing deductions is very important for the hospital. In the study of design and implementation of analytical dashboard of insurance deductions based on medical intelligence business, to improve financial management with the aim of focusing on assessing the level of satisfaction and its applicability has been done. Materials and Methods: To design the questionnaire, first 27 questions were prepared through library studies and interviews with members of the hospital board of directors, and the validity and consistency of its items were determined through content validity and Cronbach’s alpha coefficient. Data were analyzed in SPSS software and the results were used to design and implement the dashboard. Results: The study is of development-applied type. In the first phase, to determine Content Validity Ratio CVI (Content Validity Index), and CVR (Content Validity Ratio) a researcher-made questionnaire was provided to 20 experts. In the second phase, by building a data warehouse in SQL (Structured Query Language), the information of the tables related to the deductions of the hospital HIS system was transferred to it and the operational information of the organization was extracted and converted into DW format and the map information was tested. OLAP (Online Analytical Processing) services were then loaded on the created analytics database. In the last step, Power BI tool was selected and used to create business intelligence mechanisms, display and visualize information. In the third phase, using the QUIS (Questionnaire for User Interface Satisfaction) standard questionnaire, the level of satisfaction and usability of the dashboard was evaluated by 15 experts. Conclusion: In this study, two questionnaires were used. CVR was measured in all items of the first questionnaire, more than 0.50 and CVI was measured in the upper areas of 0.90 and Cronbach’s alpha coefficient was obtained between 0.8 and 0.9, which indicated a good level. The second questionnaire was to evaluate the level of satisfaction and usability of the dashboard that the average of the total evaluation based on the indicators of the QUIS questionnaire is equal to 85.40. Therefore, the level of satisfaction and usability of the dashboard was “very good” for the evaluators.